Skip to main content
Version: 8.4.08.4

ULinkContextEvent

V8 Message Definiton

METADATA

AttributeValue
Topic5745-tool-core
MLink TokenSystemData
ProductSRControl
accessTypeSELECT

Table Definition

FieldTypeKeyDefault ValueComment
userNameVARCHAR(24)PRI''
clientFirmVARCHAR(16)''
accntVARCHAR(16)''most recent SR accnt optional
ticker_atenum - AssetType'None'most recent symbol optional
ticker_tsenum - TickerSrc'None'most recent symbol optional
ticker_tkVARCHAR(12)''most recent symbol optional
sourceVARCHAR(16)''source tool name eg SV CT BBLink SRSE etc
ulinkEventVARCHAR(8)''ulink event eg F1 F2 Enter etc if any
ulinkDetailTINYTEXT''additional ulink context detail if any
timestampDATETIME(6)'1900-01-01 00:00:00.000000'timestamp of ulink initiation

PRIMARY KEY DEFINITION (Unique)

FieldSequence
userName1

CREATE TABLE EXAMPLE QUERY

CREATE TABLE `SRControl`.`MsgULinkContextEvent` (
`userName` VARCHAR(24) NOT NULL DEFAULT '',
`clientFirm` VARCHAR(16) NOT NULL DEFAULT '',
`accnt` VARCHAR(16) NOT NULL DEFAULT '' COMMENT 'most recent SR accnt (optional)',
`ticker_at` ENUM('None','EQT','IDX','BND','CUR','COM','FUT','SYN','WAR','FLX','MUT','SPD','MM','MF','COIN','TOKEN','ANY') NOT NULL DEFAULT 'None' COMMENT 'most recent symbol (optional)',
`ticker_ts` ENUM('None','SR','NMS','CME','ICE','CFE','CBOT','NYMEX','COMEX','RUT','CIDX','ARCA','NYSE','OTC','NSDQ','MFQS','MIAX','DJI','CUSIP','ISIN','BXE','ESX','ANY','CXE','DXE','NXAM','NXBR','NXDUB','NXLS','NXLDN','NXML','NXMLT','NXOS','NXP','EUREX','CEDX','ICEFE') NOT NULL DEFAULT 'None' COMMENT 'most recent symbol (optional)',
`ticker_tk` VARCHAR(12) NOT NULL DEFAULT '' COMMENT 'most recent symbol (optional)',
`source` VARCHAR(16) NOT NULL DEFAULT '' COMMENT 'source tool name (eg. SV, CT, BBLink, SRSE, etc)',
`ulinkEvent` VARCHAR(8) NOT NULL DEFAULT '' COMMENT 'ulink event (eg: F1, F2, Enter, etc) (if any)',
`ulinkDetail` TINYTEXT NOT NULL DEFAULT '' COMMENT 'additional ulink context detail (if any)',
`timestamp` DATETIME(6) NOT NULL DEFAULT '1900-01-01 00:00:00.000000' COMMENT 'timestamp of ulink initiation',
PRIMARY KEY USING HASH (`userName`)
) ENGINE=SRSE DEFAULT CHARSET=LATIN1 COMMENT='';

SELECT TABLE EXAMPLE QUERY

SELECT
`userName`,
`clientFirm`,
`accnt`,
`ticker_at`,
`ticker_ts`,
`ticker_tk`,
`source`,
`ulinkEvent`,
`ulinkDetail`,
`timestamp`
FROM `SRControl`.`MsgULinkContextEvent`
WHERE
/* Replace with a VARCHAR(24) */
`userName` = 'Example_userName';

Doc Columns Query

SELECT * FROM SRControl.doccolumns WHERE TABLE_NAME='ULinkContextEvent' ORDER BY ordinal_position ASC;